Aside

Contact

Download as a PDF


Coding


Visualization


Strength

Disclaimer

Made w/ pagedown.
Source code: Github repo.

Last updated on 2020-06-25.

Main

Dingrui(Frank) Zhang

Business Analyst | R Developer

I enjoy working with data to solve business problems and build tools that help people. My favorite part of working in data science is the constant opportunity to learn, from statistics to real business problems.

Education

Master of Professional Accounting

University of New South Wales

Sydney, Australia

2019 - 2017

Exchange Student Program (Major in Accounting)

University of New South Wales

Sydney, Australia

2017 - 2016

  • Achieved Overall Distinction WAM

Bachelor of Management (Major in Accounting)

Hebei University of Economics and Business

Shijiazhuang, China

2016 - 2013

  • Achieved Overall WAM of 80

Professional Experience

Consultant, Data Analytics

PwC Australia

Sydney, Australia

Present - 2020 Jan

  • Worked on data analysis and visualisation, and bring data analytic techniques to bear on a wide variety of problems. Workedon tight (1-3 month) timeframes to deliver bespoke work on Data Analytics to clients.

Finance Analyst

The University of Sydney

Sydney, Australia

2019 Dec - 2019 Aug

  • Improved reporting pipelines while utilising VBA and SmartView to automate processes
  • Migrated monthly financial reporting dashboards from excel-based to Power BI
  • Assisted with the preparation of reconciliations of financial and operational data from different sources and provided recommendations to Finance Managers and Head of Schools
  • Assisted with providing budget and forecast for multiple stakeholders

Data Analyst Intern

Travelzoo (NASDAQ: TZOO)

Sydney, Australia

2019 Aug - 2018 Dec

  • Developed an automated program (web scraper) that identifies and stores the marketing data in database to produce the desired reports.
  • Developed multiple macros and R scripts to collect information from multiple sources(ERP, Excel, Text …), analyse data and generate report automatically. Saved more than 50% time.
  • Collected and maintained history operation database and built up weekly operation report for the whole APAC(Asia Pacific) area.
  • Provided operations support for APAC Team, for example: overseas collection deal price point conversion.
  • Built quarterly/monthly dashboard for different countries in APAC area which provided measurements for management.

Junior Financial Analyst

UBI Logistics (Australia) Pty Ltd

Sydney, Australia

2018 Sep - 2017 Aug

  • Developed a billing system based on VBA and R which supports generating billing statements, email automation and aging analysis. This system significantly freed people from heavy and routine manual work, reduced 2 FTE (Full-time equivalent) and improved collecting accounts receivable.
  • Developed a procedure to analyse data, identify discrepancies and design reporting mechanism, which allow on-time and accurate measure of the company performance. This procedure is still utilised and has been able to recover more than 120,000 AUD in the past 1 year, which otherwise would be lost because of the information inaccuracy.
  • Built and maintained a MySQL finance database which helps finance department find discrepancies between forecast and real-time data, also responsible for designing data tables, managing permissions and setting up backups.
  • Worked as a consultant with a team of 5 co-workers from both China and Australia to establish an online invoicing system and successfully co-ordinated the project between finance and IT team.
  • Provided training to co-workers on program I developed and wrote end-user manual.

Professional Development

CFA Level 1 Passed Aug 2018 – Present

CFA Institute

N/A

Present - Aug 2018